﻿CREATE VIEW DBDictionaryService.DBInstrumentStaticDataEquityVanillaOption
(
	ID,Type,Name,DBMarketID,DBTickSizeRuleID,Currency,
	
	DBUnderlyingID,
	Sector,
	OptionType,
	ExerciseType,
	K,
	T
)
AS SELECT 
	ID,Type,Name,DBMarketID,DBTickSizeRuleID,Currency,
	
	DBUnderlyingID,
	Sector,
	OptionType,
	ExerciseType,
	K,
	T
	
FROM DBDictionaryService.DBInstrumentStaticData
WHERE Type = 'EquityVanillaOption'